<head>
		<meta http-equiv="content-type" content="text/html;charset=iso-8859-1">
		<title>FossilPlot at Idaho State University</title>
		<meta name="keywords" content="Leif Tapanila, Fossil Plot, Fossilplot, FossilPlot, fossilplot, Sepkoski, compendium, diversity, paleontology, paleoecology, evolution, curve, geoscience, education, teaching">
		<meta name="description" content="FossilPlot at Idaho State University">






<script type="text/javascript">
function lookup_phylum(){
	leftPos = 0
	  if (screen) {
		leftPos = screen.width-525
  	}
  	editWindow = window.open('phylum.php','editWindow','toolbar=no,location=yes,scrollbars=yes,width=500,height=500left='+leftPos+',top=100,alwaysRaised=true, resizable=yes');		

}

function lookup_class(){
	leftPos = 0
	  if (screen) {
		leftPos = screen.width-525
  	}
  	editWindow = window.open('class.php','editWindow','toolbar=no,location=yes,scrollbars=yes,width=500,height=500left='+leftPos+',top=100,alwaysRaised=true, resizable=yes');		

}

function lookup_order(){
	leftPos = 0
	  if (screen) {
		leftPos = screen.width-525
  	}
  	editWindow = window.open('order.php','editWindow','toolbar=no,location=yes,scrollbars=yes,width=500,height=500left='+leftPos+',top=100,alwaysRaised=true, resizable=yes');		

}

function lookup_absdates(){
	leftPos = 0
	  if (screen) {
		leftPos = screen.width-525
  	}
  	editWindow = window.open('absdates.php','editWindow','toolbar=no,location=yes,scrollbars=yes,width=500,height=500left='+leftPos+',top=100,alwaysRaised=true, resizable=yes');		

}


</script>


</head>



<body background="ripple2.jpg">
<table width="611" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr> 
    <td height="95"><img src="FossilPlot-Banner.jpg" width="611" height="118" align="center"></td>
  </tr>
</table>
<table width="611" border="0" align="center">
  <tr> 
    <td width="118"> 
      <div align="left"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=4,0,2,0" width="117" height="25">
          <param name=movie value="button2.swf">
          <param name=quality value=high>
          <param name="BGCOLOR" value=""><param name="SCALE" value="noborder">
          <embed src="button2.swf" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="117" height="25" bgcolor="" scale="noborder">
          </embed> 
        </object></div>
    </td>
    <td width="117"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=4,0,2,0" width="117" height="25">
        <param name=movie value="button3.swf">
        <param name=quality value=high>
        <param name="BGCOLOR" value=""><param name="SCALE" value="noborder">
        <embed src="button3.swf" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="117" height="25" bgcolor="" scale="noborder">
        </embed> 
      </object></td>
    <td width="118"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=4,0,2,0" width="117" height="25">
        <param name=movie value="button4.swf">
        <param name=quality value=high>
        <param name="BGCOLOR" value=""><param name="SCALE" value="noborder">
        <embed src="button4.swf" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="117" height="25" bgcolor="" scale="noborder">
        </embed> 
      </object></td>
    <td width="118"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=4,0,2,0" width="117" height="25">
        <param name=movie value="button5.swf">
        <param name=quality value=high>
        <param name="BGCOLOR" value=""><param name="SCALE" value="noborder">
        <embed src="button5.swf" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="117" height="25" bgcolor="" scale="noborder">
        </embed> 
      </object></td>
    <td width="118"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=4,0,2,0" width="117" height="25">
        <param name=movie value="button1.swf">
        <param name=quality value=high>
        <param name="BGCOLOR" value=""><param name="SCALE" value="noborder">
        <embed src="button1.swf" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="117" height="25" bgcolor="" scale="noborder">
        </embed> 
      </object></td>
  </tr>
</table>

<table width="611" border="0" align="center">
<tr>
<td>

<?php
echo " <a href=\"javascript:lookup_phylum()\">View Phylum</a> ";
?>

</td>

<td>

<?php
echo " <a href=\"javascript:lookup_class()\">View class</a> ";
?>

</td>
<td>

<?php
echo " <a href=\"javascript:lookup_order()\">View order</a> ";
?>

</td>



<td>

<?php
echo " <a href=\"javascript:lookup_absdates()\">View absdates</a> ";
?>

</td>

<tr>
</table>



<?php
$username = "fossilplot";
$password = "fossilplot";
$hostname = "localhost"; 




//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password)
 or die("Unable to connect to MySQL");


//select a database to work with
$selected = mysql_select_db("fossilplot",$dbhandle)
  or die("Could not select examples");

//execute the SQL query and return records
$result = mysql_query("SELECT id, class_name FROM class");

echo "<table width=661 align=center>";
echo "<tr><td>";
echo "Please enter the query:<br>";
echo "<form name= f0 action=selection1.php method=POST>";
echo "<input type=text name=myquery value='select * from genus where ' size=50> ";
echo "<input type=submit name =Submit1 value=Search><br>";

echo "</form>";
echo "</tr></td>";


echo "<tr><td>";

echo "OR:";
echo "</tr></td>";


echo "<tr><td>";
echo "Please select class:<br>";
echo "<Form name = f1 method=POST action=selection.php>";
echo "<SELECT NAME = fclass[] size = 5 multiple>";
while ($row = mysql_fetch_array($result)) {
   echo "<OPTION VALUE =\"".$row{'class_name'}."\">".$row{'class_name'}."</OPTION>";
   
}
echo "</td></tr>";

echo "<tr><td>";
echo "Please select order:<br>";
echo "<SELECT NAME = order[] size = 5 multiple>";
$result = mysql_query("SELECT id, order_name FROM fossilplot.order");
while ($row = mysql_fetch_array($result)) {
   echo "<OPTION VALUE =\"".$row{'order_name'}."\">".$row{'order_name'}."</OPTION>";
   
}
echo "</td></tr>";

echo "<tr><td>";
echo "Please select phylum:<br>";
echo "<SELECT NAME = phylum[] size = 5 multiple>";
$result = mysql_query("SELECT id, phylum_name FROM fossilplot.phylum");
while ($row = mysql_fetch_array($result)) {
   echo "<OPTION VALUE =\"".$row{'phylum_name'}."\">".$row{'phylum_name'}."</OPTION>";
   
}
echo "</td></tr>";


echo "<tr><td>";
echo "</SELECT>
          <input type=\"submit\" name=\"Submit\" value=\"Get Selected Items\">";
        
echo "</td></tr>";
echo "</table>";
echo "</form>";
//close the connection
mysql_close($dbhandle);



?>
        


 


<!-- Site Meter -->
<script type="text/javascript" src="http://s29.sitemeter.com/js/counter.js?site=s29FossilPlot">
</script>
<noscript>
<a href="http://s29.sitemeter.com/stats.asp?site=s29FossilPlot" target="_top">
<img src="http://s29.sitemeter.com/meter.asp?site=s29FossilPlot" alt="Site Meter" border="0"/></a>
</noscript>
<!-- Copyright (c)2006 Site Meter -->
</html>